Age Distribution Analysis with Collapsed Age Groups
Updated Analysis with 5 Age Brackets
Marco Pena
2025-06-16
1 Age Group Consolidation Summary
Original Age Groups (10): Under 25, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65 or older
New Age Groups (5): - Under 30 (combines Under 25 + 25-29) - 30-39 (combines 30-34 + 35-39) - 40-49 (combines 40-44 + 45-49) - 50-59 (combines 50-54 + 55-59) - 60+ (combines 60-64 + 65 or older)
## === Sample Sizes with Collapsed Age Groups ===## 2020 Dataset by Age:##
## Under 30 30-39 40-49 50-59 60+
## 232 687 665 647 356##
## 2025 Dataset by Age:##
## Under 30 30-39 40-49 50-59 60+
## 211 577 743 571 310##
## === 2020 Age-Gender Cross-tabulation (Collapsed Groups) ===##
## Men Nonbinary Women
## Under 30 30 0 202
## 30-39 90 1 596
## 40-49 109 1 555
## 50-59 112 1 534
## 60+ 112 0 244##
## === 2025 Age-Gender Cross-tabulation (Collapsed Groups) ===##
## Men Nonbinary Women
## Under 30 22 2 187
## 30-39 77 2 498
## 40-49 94 2 647
## 50-59 88 1 482
## 60+ 57 3 2502 Age Distribution Visualizations
2.1 Chart 1: Age-Gender Distribution Comparison (All Datasets)
Age-Gender Distribution with Collapsed Age Groups
2.2 Chart 2: Age Distribution Trends Across Datasets
Age Distribution Trends with Collapsed Groups
2.3 Chart 3: Demographic Shift Analysis (2025 vs 2020)
Demographic Changes with Collapsed Age Groups
2.4 Chart 4: Impact of Weighting on 2025 Distribution
Effect of Weighting with Collapsed Age Groups
2.5 Chart 5: Sample Size Comparison (Before vs After Collapse)
## === Minimum Cell Sizes Comparison ===## Collapsed (5 groups):## Men: 22## Women: 187## Nonbinary: 1##
## Original (10 groups):## Men: 4## Women: 38## Nonbinary: 0
Sample Size Improvement from Age Group Consolidation